Prerequisites

Source Database

The source database ARCHIVESSOURCE is the database on which OIPA application is running and from which the data will be archived.

Make sure the below changes are present in source database:

• SUBSTATUSCODE column from ASACTIVITY table has been renamed to ARCHIVALSTAUSCODE (10) (The liquibase file "pas.database/updates/12.0.0.0/2022-09-12_OIPAJ-19433.xml" contains the change and it should be ran successfully - verify in databasechangelog table).

• STATUSCODE column length from ASACTIVITY table has been changed from 2 char to 10 char (The liquibase file "pas.database/updates/12.0.0.0/2022-10-11_OIPAJ-21390.xml" contains the change and it should be ran successfully - verify in databasechangelog table)

Target Database

The target database ARCHIVESTARGET is the database to which the archived data will be moved.

Create a new schema for target database to where the records from source will be moved and make sure tables can be created on that. The new schema can be in the same instance or a separate instance.

Use the below commands to create a target schema:

Oracle

create user ARCH_TARGET identified by ARCH_TARGET;

grant connect, resource to ARCH_TARGET;

grant UNLIMITED TABLESPACE to ARCH_TARGET;

MSSQL Server

Create the below database:

ARCH_TARGET - user with full privileges.

DB2

Create the below database:

ARCH_TARGET - user with full privileges.

Since DB2 uses the operating system for authentication, the user must first be created at the operating system level. Please consult the operating system documentation for creating users.